1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class Kho_KiemKhoMod
15 {
16 protected int PageSize { get; set; }
17 protected int PageIndex { get; set; }
18
19 protected int IdKho_KiemKho { get; set; }
20 protected string TrangThai { get; set; }
21 protected float TongSoMatHangTrongKho { get; set; }
22 protected float TongSoMatHangKiemKho { get; set; }
23 protected string DienGiai { get; set; }
24 protected DateTime NgayKiemKho { get; set; }
25
26 public Kho_KiemKhoMod()
27 {
28 }
29
30 public Kho_KiemKhoMod(int _IdKho_KiemKho)
31 {
32 IdKho_KiemKho = _IdKho_KiemKho;
33 }
34
35 public Kho_KiemKhoMod(int _IdKho_KiemKho, string _TrangThai, float _TongSoMatHangTrongKho, float _TongSoMatHangKiemKho, string _DienGiai, DateTime _NgayKiemKho)
36 {
37 IdKho_KiemKho= _IdKho_KiemKho;
38 TrangThai= _TrangThai;
39 TongSoMatHangTrongKho= _TongSoMatHangTrongKho;
40 TongSoMatHangKiemKho= _TongSoMatHangKiemKho;
41 DienGiai = _DienGiai;
42 NgayKiemKho = _NgayKiemKho;
43 }
44
45 public Kho_KiemKhoMod(int _IdKho_KiemKho, string _TrangThai, float _TongSoMatHangTrongKho, float _TongSoMatHangKiemKho, string _DienGiai, DateTime _NgayKiemKho, int _PageSize, int _PageIndex)
46 {
47 IdKho_KiemKho = _IdKho_KiemKho;
48 TrangThai = _TrangThai;
49 TongSoMatHangTrongKho = _TongSoMatHangTrongKho;
50 TongSoMatHangKiemKho = _TongSoMatHangKiemKho;
51 DienGiai = _DienGiai;
52 NgayKiemKho = _NgayKiemKho;
53 PageSize = _PageSize;
54 PageIndex = _PageIndex;
55 }
56
57
58 public int InsertKho_KiemKho()
59 {
60 int i = 0;
61 string[] paras = new string[6] { "@IdKho_KiemKho", "@TrangThai", "@TongSoMatHangTrongKho", "@TongSoMatHangKiemKho", "@DienGiai", "@NgayKiemKho"};
62 object[] values = new object[6] { IdKho_KiemKho, TrangThai, TongSoMatHangTrongKho, TongSoMatHangKiemKho, DienGiai, NgayKiemKho };
63 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_Kho_KiemKho_Insert", CommandType.StoredProcedure, paras, values));
64 return i;
65 }
66
67 public int UpdateKho_KiemKho()
68 {
69 int i = 0;
70 string[] paras = new string[6] { "@IdKho_KiemKho", "@TrangThai", "@TongSoMatHangTrongKho", "@TongSoMatHangKiemKho", "@DienGiai","@NgayKiemKho" };
71 object[] values = new object[6] { IdKho_KiemKho, TrangThai, TongSoMatHangTrongKho, TongSoMatHangKiemKho, DienGiai, NgayKiemKho };
72 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_Kho_KiemKho_Update", CommandType.StoredProcedure, paras, values));
73 return i;
74 }
75
76
77 public int DeleteKho_KiemKho()
78 {
79 int i = 0;
80 string[] paras = new string[1] { "@IdKho_KiemKho"};
81 object[] values = new object[1] { IdKho_KiemKho};
82 i = Models.connection.Excute_Sql("tbl_Kho_KiemKho_Delete", CommandType.StoredProcedure, paras, values);
83 return i;
84 }
85
86 //lay tat ca danh sach kiem kho
87 public DataSet FillDataSet_getKho_KiemKho_Search()
88 {
89 DataSet ds = new DataSet();
90 string[] paras = new string[8] { "@IdKho_KiemKho", "@TrangThai", "@TongSoMatHangTrongKho", "@TongSoMatHangKiemKho", "@DienGiai", "@NgayKiemKho", "@PageSize", "@PageIndex" };
91 object[] values = new object[8] { IdKho_KiemKho, TrangThai, TongSoMatHangTrongKho, TongSoMatHangKiemKho, @DienGiai ,NgayKiemKho, PageSize, PageIndex};
92 ds = Models.connection.FillDataSet("tbl_Kho_KiemKho_Search", CommandType.StoredProcedure, paras, values);
93 return ds;
94 }
95
96 //lay tho idkiemkho
97 public DataSet FillDataSet_getKho_KiemKho_Get_ByIdKiemKho()
98 {
99 DataSet ds = new DataSet();
100 string[] paras = new string[1] { "@IdKho_KiemKho"};
101 object[] values = new object[1] { IdKho_KiemKho};
102 ds = Models.connection.FillDataSet("tbl_Kho_KiemKho_Get", CommandType.StoredProcedure, paras, values);
103 return ds;
104 }
105 }
106 }